from os import name

import addr as addr
import comname as comname
import salary as salary

import pymysql
from example import req

db=pymysql.connect(host='localhost',user='root',password='xxxx',port=3306,db='test')
cursor=db.cursor()
sql='CREATE TABLE'zhitong'('\
    'comname varchar(50),'\
    'address varchar(30),'\
    'requirement varchar(20),'\
    'salary varchar(10),'\
    'name varchar(50),'\
    'information varchar(20)'\
    ')ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;'
cursor.execute(sql)
cursor.execute("INSERT INTO zhitong VALUES(%s,%s,%s,%s,%s,%s)",(comname,addr,req,salary,name,desc))